PopulationVariance (fld), PopulationVariance (fld, condFld), PopulationVariance (fld, condFld, cond), PopulationVariance (x)

Basic and Crystal syntax.

Arguments
Returns

Fractional Number

Action

Enables you to find the population variance of a set of values in your report. For example:

Examples

The following examples are applicable to both Basic and Crystal syntax:

For examples of each PopulationVariance function, click on the corresponding summary function.

PopulationVariance({file.CENSUS})

Calculates the variance of all values in the Census field.

PopulationVariance({file.RESULTS}, {file.PROCEDURE})

Calculates the population variation for each group of laboratory test results in the Results field. The test results are separated into groups whenever the value in the Procedure field changes.

PopulationVariance({file.SCORES}, {file.NATURALIZED}, "any change")

Groups values in the Scores field based on whether or not the test taker is a naturalized citizen, and calculates the population variance for each group of scores.

The following examples are applicable to Crystal syntax:

PopulationVariance({file.SCORES}, {file.TEACHERS}) % PopulationVariance({file.TEACHERS})

Groups values in the Scores field by teacher, and calculates the population variance for each teacher group as a percentage of the population variance of the values for the entire report (for all teachers listed).

PopulationVariance([2,4,6,8,10])

Returns 8.

Comments

Population variance is calculated using the following technique:

Note:    Using this function in a formula forces the formula to be evaluated at print time.

For more information on evaluation time considerations, see Evaluation Time functions.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com